[dbo].[AsiNrdsMemberSupplemental]

Property	Value
Created	3:53:49 PM Tuesday, November 22, 2011
Last Modified	11:40:00 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_AsiNrdsMemberSupplemental: ID\SEQN$	ID	varchar(10)	10	('')
$Cluster Primary Key PK_AsiNrdsMemberSupplemental: ID\SEQN$	SEQN	int	4	((0))
	AssociationId	varchar(4)	4	('')
	LocalJoinDate	datetime	8
	MemberId	varchar(9)	9	('')
	MemberType	varchar(4)	4	('')
	OfficeId	varchar(9)	9	('')
	RELicense	varchar(11)	11	('')
	Status	varchar(1)	1	('')
	StatusDate	datetime	8
	Subclass	varchar(4)	4	('')
	NARTimestamp	varchar(20)	20	('')
	TIME_STAMP	timestamp	8

	Name	Columns	Unique
$Cluster Primary Key PK_AsiNrdsMemberSupplemental: ID\SEQN$	PK_AsiNrdsMemberSupplemental	ID, SEQN

SQL Script

CREATE TABLE [dbo].[AsiNrdsMemberSupplemental]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_ID] DEFAULT (''),
[SEQN] [int] NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_SEQN] DEFAULT ((0)),
[AssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_AssociationId] DEFAULT (''),
[LocalJoinDate] [datetime] NULL,
[MemberId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_MemberId] DEFAULT (''),
[MemberType] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_MemberType] DEFAULT (''),
[OfficeId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_OfficeId] DEFAULT (''),
[RELicense] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_RELicense] DEFAULT (''),
[Status] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_Status] DEFAULT (''),
[StatusDate] [datetime] NULL,
[Subclass] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_Subclass] DEFAULT (''),
[NARTimestamp] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberSupplemental_NARTimestamp] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AsiNrdsMemberSupplemental] ADD CONSTRAINT [PK_AsiNrdsMemberSupplemental] PRIMARY KEY CLUSTERED ([ID], [SEQN]) ON [PRIMARY]
GO